package com.jvyou.pms.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.jvyou.pms.domain.entity.JhyJhyzdxx;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;

/**
 * (JhyJhyzdxx)表数据库访问层
 *
 * @author 橘柚
 * @since 2025-06-29 01:20:30
 */
public interface JhyJhyzdxxMapper extends BaseMapper<JhyJhyzdxx> {

    IPage<JhyJhyzdxx> getDeviceUptimeByKb(@Param("page") IPage<JhyJhyzdxx> page,
                                          @Param("ew") QueryWrapper<JhyJhyzdxx> ew,
                                          @Param("kssj") LocalDateTime kssj,
                                          @Param("jssj") LocalDateTime jssj);

    @MapKey("sblx")
    List<Map<String, Object>> getNumBySblx(@Param("sblxList") List<String> sblxList, @Param("yq") String yq);

    @MapKey("jhycj")
    List<Map<String, Object>> getSbcsInfo(@Param("sblx") String sblx,@Param("yq") String yq);


}
